package com.lovo.boot.dao;

import com.lovo.boot.bean.Emp;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lovo.boot.dto.EmpInfoDto;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author ren
 * @since 2022-03-22
 */
@Mapper
public interface EmpMapper extends BaseMapper<Emp> {
//    @Select("SELECT e_id,e_name,e_birthday,e_nowpost,e_nowsalary,i_id,i_post,i_salary,i_time FROM t_emp INNER JOIN t_info on t_info.fk_empId=t_emp.e_id WHERE e_id=#{id}")
//    @ResultMap(value = "com.lovo.boot.dao.EmpMapper.empMap")
    List<Emp> findEmpListById(Integer id);
    List<EmpInfoDto> findEmpListByName(String name);

}
